




set more off


replace country = trim(lower(country))
replace country = subinstr(country,"-","",.)
replace country = subinstr(country,"&","and",.)
replace country = subinstr(country,".","",.)
replace country = subinstr(country,",","",.)
replace country = subinstr(country,"'","",.)
replace country = subinstr(country," ","",.)
replace country = "congo" 				if country=="congorep"
replace country = "rca" 				if country=="centralafricanrepublic"
replace country = "rdc" 				if country=="congodemrep"
replace country = "rdc" 				if country=="congodrc"
replace country = "rdc" 				if country=="drc"
replace country = "rdc" 				if country=="democraticrepublicofthecongo"
replace country = "rca" 				if country=="centafrep"
replace country = "drc" 				if country=="congo(drc)"
replace country = "egypt" 				if country=="egyptarabrep"
replace country = "caboverde" 			if country=="capeverde"
replace country = "southafrica" 		if country=="safrica"
replace country = "equatorialguinea" 	if country=="eqguinea"
replace country = "swaziland" 			if country=="eswatini"
replace country = "tanzania"			if country=="unitedrepublicoftanzania"
replace country = "sudan"			 	if country=="sudan(former)"
replace country = "algeria"				if country=="algiers"
replace country = "gambia" 				if country=="gambiathe"
replace country = "cotedivoire" 		if country=="côtedivoire"
replace country = "cotedivoire" 		if country=="cÙtedivoire"
replace country = "cotedivoire" 		if country=="c√¥tedivoire"
replace country = "cotedivoire" 		if country=="ivorycoast"

